UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27PTRGz5ZIeByY9tpuIEGC9prtgo+/aGHPV4xJ9GuPs='
WHERE
key_id = 'e0b257b60dba9b1126dd4fbf86393f4f48bba73147dd6bbbad819885d3c6b9af'
AND (
token = '27PTRGz5ZIeByY9tpuIEGC9prtgo+/aGHPV4xJ9GuPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)