UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PkQGdMbkcNdxy6ZAFup+IPqf3Vb2mbSYR86k/GDzdgs='
WHERE
key_id = '24a287f3f429c5cf364f194b5121c5f57131268cf79d08482bbb280a1f40a399'
AND (
token = 'PkQGdMbkcNdxy6ZAFup+IPqf3Vb2mbSYR86k/GDzdgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)