UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CE84/56MtwQYVP8BNBPjUDp57L6412sqWgcqSvun4cM='
WHERE
key_id = '78daabd6abf97c1c55bdd1ad03aec0e02aedc923730fb1d9130e41ad2ea1dec1'
AND (
token = 'CE84/56MtwQYVP8BNBPjUDp57L6412sqWgcqSvun4cM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)