UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNGmGrgAHe/MrAjiopZz6Nw3/bmxTp+wkF3Wc1LZaQQ='
WHERE
key_id = '7bc624f6995655a42900de9a987e49cda345250c30c3ba6a669d61f898a0e517'
AND (
token = 'pNGmGrgAHe/MrAjiopZz6Nw3/bmxTp+wkF3Wc1LZaQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)