UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3KJcjpkAkFaRi8CbC70Owol+ta1gOebDSjGBsZNQreM='
WHERE
key_id = '43c27397662bb0b28820c2b4dea93d3b027be313ba6b6979121936af93e30594'
AND (
token = '3KJcjpkAkFaRi8CbC70Owol+ta1gOebDSjGBsZNQreM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)