UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hbPIlb1s2fOuK1tg2yOPUL9j4+QNyPsvdkWloLW9j3E='
WHERE
key_id = 'd187b59cd9c91fdc39b35dbe0de7b729bf029f53cbae75c1e0fc2041b8db910c'
AND (
token = 'hbPIlb1s2fOuK1tg2yOPUL9j4+QNyPsvdkWloLW9j3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)