UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J40IpG2Bx9ID+zw4lfH9vjq1gteN7vPZICBpD5sA9PI='
WHERE
key_id = '55d4aef3d5887859bfffcf38e2151df38437a1e3505801c98a7b14ca6d6ca151'
AND (
token = 'J40IpG2Bx9ID+zw4lfH9vjq1gteN7vPZICBpD5sA9PI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)