UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQEIpK4P4Td6Lxz8bNcpk7gwd6IPAuzjnD0/cy7jFCc='
WHERE
key_id = '5b399c15c074ce4bf9c780f70e5efe176643c9952d6585017dc640898feee0b9'
AND (
token = 'XQEIpK4P4Td6Lxz8bNcpk7gwd6IPAuzjnD0/cy7jFCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)